sqlReports.xlsx

sqlREPORTS by Category
Report Name	Description	Restricted
A New Student Search
Student Search by Date of Birth	Purpose of this report is to search the entire student table for all records that match the entered date of birth.
Aqua & Magnet Schools
Aqua Q1 Grades to Export	The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q1 report will include Q1 letter grade and percent along with the number of absences.
Aqua Q2 Grades to Export	The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q2 report will include Q2, E1, S1 and Y1 letter grade and percent along with the number of absences.
Aqua Q3 Grades to Export	The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q3 report will include Q3 letter grade and percent along with the number of absences.
Aqua Q4 Grades to Export	The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q4 report will include Q4, E2, S2 and Y1 letter grade and percent along with the number of absences.
Intra-District Grades Report	This report is intended to be used to send grades of non resident students to their home Districts. The report is generated from the stored grades for the current year. Only the permanent marking terms are being reported, not the Progress Report grades. Please note if no grades have been stored there will be no results. However, if the P1 grades were stored but not the Q1 grades, you will get a report with students, course and absences but no current grades.NOTE: The report must be run within a school.
Attendance
Absences by Student	This report lists all students in a specified school along with their Grade Level, Homeroom, Absences (Unexcused, Excused & Medical Absences), OSS, Tardy and Total Days absent.

Absent Report for a Student

This report will list every Absence and Tardy, including the school attended at the time, for a select student (be sure to select student before selecting sqlReports tab) for their entire history in Bridgeport School District .

ADA for All Schools

Report to display Average Daily Attendance for all

schools between a date range

Restricted

Attendance and Absence Rates by Date

This report list the number of students absent, school membership, absence rate, and attendance

rate by date.

Restricted

Attendance by Grade for Today

The purpose of this report is to provide a simple

attendance of active students for today only.

Attendance Intervention Report

The purpose of the Attendance Intervention Report is to list all active students, with the exception of Pre- K students,within a selected school that have 2 or more unexcused absences for the entire current school year, no matter what school the students was attending this year. The the dates from the each activity contained on the Special Attendance page will also be dispalyed.

Bridgeport Truancy

This report lists the students with the number of unexcused absences as defined by the criteria selected. It is the same report that appears on the 'System Reports' page but due to the PowerSchool

upgrade it isn't working properly.

Child Find Report for a School

Child Find Report lists all students within a selected school that have 2 or more unexcused absences and will list the Child Find activity contained on the Special Attendance Support page.

Chronic Absenteeism Current Summary for a School

This report must be run within a school and will result in the current enrollment, non-chronic total, chronic total and chronic percentage for that school as of today.

NOTE: This report is intended to help the school improve their attendance by reporting the data available at the moment. The official report is produced at the end of each day. As a result of these report being produced at different times, the

data from the two reports may vary slightly.

Chronic Absenteeism Report - Student Listing

The is a similar report to the Crystal Report sent via email. However, it may very slightly since this is a dynamic report using real-time data. Whereas, the Crystal Report is run nightly. This is one report for all schools, therefore the Conslr/HR RM field for Elementary is the Homeroom room number and for High Schools, the field is the Counselor.

In addition, since the State is not concerned with Pre- K attendance, these grades are not included.

NOTE: Must be run within a school.

Chronically Absent

USE THIS REPORT WITH CAUTION. THE CHRONIC REPORT FROM THE CRYSTAL SERVER THAT IS EMAILED TO SCHOOLS WILL BE USED AS THE "OFFICIAL" REPORT. THIS REPORT IS DONE BASED ON THE TIME IT IS RUN. THEREFORE, ANY ATTENDANCE CHANGES DONE WILL BETWEEN THE TIME THE CRYSTAL WAS DONE AND THIS REPORT WAS RUN WILL CAUSE A DISPARITY BETWEEN THE TWO REPORTS.

Students are chronically absent when they are absent 10% or more. This report includes all absences within this school regardless of excused or unexcused. NOTE: this report defaults to the school you are logged into. For District users, you should select a school prior to running this report unless you want each chronically absent student in the entire District.

Daily Attendance Review

The purpose of this report is to review the 'daily' attendance recorded for all students within a school.

Elementary Daily Attendance

The intention of this report is to list every active student and their daily attendance for a specific day. In order to be sure each student as a daily attendance record for the date being reviewed. The 'Daily Att Code' column is the attendance code that has been entered for the day. The dash ('-') in this column signifies that there isn't any attendance code for the day, however, the default will be 'Present', indicating an in-school presence. The column labeled 'Meet Codes' is a collection of all the codes taken during the day for this student by the teachers. For example, a student may have a Meet Codes like 'VAB,VAB,VAB,VP,VP'. This means 5 teachers entered an attendance for this student on that particular day. Please be aware if attendance was taken and the student was present in school and in the class, the default is blank. Therefore, the student may have a 'Meet Codes' looking like this 'ABSNT,TRDY' but the student was present for the remainder of his classes and may have a '-' for the daily attendance code. This report must be run from within a school.

High School Daily vs ADA (Meeting)

This report is intended to show any student that should have been marked absent based on the Meeting Attendance but does not have the date marked as an absence in the Daily Attendance. The reverse of this will also be shown where there is an absence in the Daily Attendance but the Meeting Attendance does not reflect an absence. The Meeting Attendance can be seen if you run the 'ADA/ADM by Date' for a student and chose Meeting Attendance and use the Period to Day calculation.

The resulting display will indicate absences by a '0' in the 'Attendance' column.

The High School Daily vs ADA report can be run from any school or District level.

No Shows

This report is meant to determine those students that never arrived since the first day of school. The report is for an individual school. Please note for High Schools the Daily attendance must be updated first.

Since it is possible that a teacher didn't take attendance and therefore the student appears as Present, we have based the student output if their absences are within 75% of their membership days.

Perfect Attendance for a School

This is a listing of students within a specific school

from the beginning of the year to current day with Perfect Attendance.

Perfect Attendance for Homerooms

This report is intended to show Elementary Homerooms that have Perfect attendance for a date range. For users with multiple school access, you will need to be in the school you want the attendance in. NOTE: Tardy and ISS are both Present codes and therefore a classroom would have Perfect Attendance even if students were tardy or in ISS.

Perfect Attendance Within a Date Range

The report will list all students without any absences within a date range. The list will include those students that may have been tardy during that period and they will be noted "TARDY". The report allows for filtering. If you want Perfect Attendance without these students, you can filter them out.

Please note you will need to be logged into a school. This does not work at District level.

Period to Day Attendance

This report is intended to assist high schools to enter daily attendance for students that have missed 50% of the school day. It is run for each day and will display only those students that have missed more than half the school day based on their schedule.

As a result, if a student has only 3 classes and misses 2 he will appear on the report an should be marked absent for the day. The learning prefernce (in-school vs distant) is listed on the report as well as the attendance codes that were recorded for the day in order to help you determine whether the student should be ABSNT or VAB for the day.

School Present Count

This report will show the number of students present, absent and enrolled in a schools on any school day for any year. The report must be run from

within a school.

School Present Count with Remote

This report will show the number of students present and absent for both In School and Distant Learning for a school on a specific day. The report must be

run from within a school.

Special Attendance Report

Listing of students with any data on the Special Attendance page in PowerSchool.

MUST BE RUN WITHIN A SCHOOL.

Student List with Tardy Count

This report will list students within a school that have been tardy at least once in the current school year along with the total number of times the student was tardy for the day since the beginning of school to present.

NOTE: You must run this report within a school.

Student Membership & Absence

This report will list membership and absences for active students within a school for the current school year. Along with attendance, the student's grade level, age, home language and the percentage of absences.

NOTE: You must be logged into a school.

Student Membership and Absences by Date Range

This report will list membership and absences for active students within a school for the current school year within a date range. Along with attendance, the student's grade level, age, homeroom and homeroom teacher are listed.

NOTE: You must be logged into a school.

Bassick

Failure Rate from Stored Grades	This report lists teachers from the Historical Grades database. Grouped by Course, the report shows the total number of students, the number of "F's" and the Failure Rate (fail/total). NOTE: This report searches the "Stored" grades table. This table will include teacher names that may not be in your school because this table stores the grades from new students entering from outside our District. Also note that you need to be in a school to run the report. Running the report from District will take forever and may be pointless.
Scheduling Dependent Sections	The report is intended for Bassick use only in determining the enrollment of students in courses with dependent sections. The program currently only works if there is only one dependent section.
Scheduling Teams Enrollment	This report is intended exclusively for Bassick to aid in scheduling the 2020-2021 School Year.
Stored Grades Listing	This report lists all records in the Historic Grades table by teacher, student, course and grades for a specific marking period of the current year. NOTE: This report must be run from within a school. ALSO NOTE: Since these records are from the stored grades table, counselors would be adding grades for new students coming in from outside of our District. These grades may not include the teacher name or a name not familiar to the present school. However, the report can be filtered to eliminate those records.
Bilingual
Active ELL Students with Creation Date	The intention of this report is to list only ELL students within a school and the date their record was either created or imported from SASI.
Annual Review	This report will list all high school ELL students along with the school they are attending and the their ESOL teacher if the student is attending an ESOL class. If the student is not attending an ESOL class the teacher will be designated as "Unassigned"
Bilingual Assessment Worksheet	This is a first attempt to provide Bilingual teachers a uniform spreadsheet for reporting purposes

Bilingual Classes for District	This report is designed to show all the bilingual homerooms in the District along with the teacher and class count. The report is based on the teacher designation as 'Bilingual'. If the teacher is not marked as 'Bilingual' in the demographics page or if the teacher is no longer a bilingual teacher, the report will be incorrect.
Bilingual Newly Arrived	This report attempts to identify students that may need bilingual services who have just arrived. This report is based on all active students that have answered one of the first three questions on the Home Language Survey with a language other than English (001). In order to filter only those students from the date chosen, the entry date is compared to any re-enrollment records that may precede the entry date.	Restricted
Bilingual Newly Arrived Summary	ELL Students who were entered into PowerSchool after 7/1/2017
Bilingual Students Requiring Testing	The intention of this report is to identify those students who have completed the Home Language Survey and at least one of the first three questions was answered with a language other than English and they have not been identified with an LDC code.
ELL Code Errors	This report lists ELL students throughout the District that have an ELL Code that may not be correct.
ELL is N but LDC is A, B or X	This report will list all active students, with the exception of NRP and OOD students, whose ELL indicator is missing or 'N' but they have an A, B or X in the Language Dominance Classification (LDC) field.
ELL Students By School	Listing of all ELL students for a selected school. With the ability to make the listing the "Current Student Selection".
ELL Total Count by School	This report displays a simple count of all students with a "Y" in the ELL status code.
Homeroom Enrollment for Bilingual	The purpose of this report is to enable Bilingual to place newly arrived students in elementary schools that have enough room. This report lists all Elementary Homerooms throughout the District with the capacity and currently enrolled students along with the school and teacher.	Restricted
Languages Used in District	This is a listing of all languages as reported in the student's record as Primary Language.
LAS Link Placement Students	This report will list students that have entered the District from the date selected to present. These students are either marked ELL or have answered the Home Language Survey with a language other than English for questions 1 through 3. The list will include their LAS Link Placement Overall score if they have been taken.

New Students This Year

The purpose of this report is to identify ELL students that were newly registered in PowerSchool this year. However, to compensate for human error, included in the report are all students registering this year.

The student's data contains their ELL and enrollment status and can be filtered to provide a tailored listing.

Primary Language or LDC Missing

This report will list all students from kindergarten through grade 12 that are missing either the Primary Language or LDC. The Primary Language is based on the primarylanguage field in the extended table

StudentCoreFields.

School Summary by Grade With Bilingual and SPED

This report will breakdown the Portuguese ELL, ELL less Portuguese, Students in a Bilingual class, SPED students in a Self Contained class and all SPED less those in Self Contained classes.

Please note:

You must be in a school to run report.
The Portuguese count is based off of the Primary Language.
If the Primary Language is "003" the student will be counted as Portuguese.
Students in a Bilingual class are counted if the student is ELL and has classes given by a teacher designated as "Bilingual".
Similarly, SPED students in a class given by a teacher designated as "SPED-SC" will be counted

as Self Contained.

Student List with Language in a School

This is a listing of all students within a school and their language as reported in the student's record as

Primary Language.

Control Transfers

Administrative Transfers

Listing of all students marked as having an Administrative Transfer whether active or inactive.

Control Transfer Listing

This a list of all students who have been designated as being on a Control Transfer. Since the report is to be used for data cleaning, both active and inactive

students are included.

Control Transfer Report

This report will select only those students within a particular school who's Control Transfer is checked and will display the revoke dates and reasons that

are filled in.

Control Transfers No Longer at CT School

Listing of students given Control Transfers but no

longer at Control Transfer designated school

Control Transfers with Revocation Dates

This report is intended to show any active student with a Control Transfer that have been given a Revocation Letter. This will also display those students that have received a final revocation but are still marked as a Control Transfer.

Overcrowding Listing	This a list of all students who have been designated as attending a school in another neighborhood due to Overcrowding. Since the report is to be used for data cleaning, both active and inactive students are included.
Overcrowding No Longer at OC School	Listing of students given transfers due to Overcrowding but no longer at the intended school.
Counselors
Missing Historical Grades	This report is intended to identify newly enrolled high school students that would normally have historical grades transferred but there are currently none in the storedgrades table. This report must be run from within a school.
Students in Wrong Grade by Credit Hrs	The intention of this report is to list those students whose current grade level does not correspond to the grade level as defined by their earned credits.The first year of high school is calculated from the historical grades table. Using the earliest recorded year for grades stored when student was in 9th grade. If the student transferred into a Bridgeport high school, it is imperative the guidance counselor record the correct and complete information into the historical grades table. In addition, the report calculates if the student has repeated a grade by subtracting the student's first year of high school from the current school year and comparing the difference. The data displayed in the report is the student number, name, 1st year of high school,repeat or not, current grade, DOB, age, SPED, ELL, number of credits earned and what the grade should be based on the credits. NOTE: The grade level from credits is based on whether the student started school before 2019 when the required credits to graduate was 22.5 or after when the credits required are 25. Also, this report does take a few minutes to run and must be run within a school.
Course Catalog
High School Course Catalog for District	This report lists all active courses for High Schools throughout the District. The list is by course name but contains the schema breakdown allowing you to filter by Department, Classification (STEM/Humanities), Tier, length of course (year long vs semester), Type (TD=Traditional, SC=Self Contained, etc), Rigor and added GPA value.
High School Courses with Active Students	This report is similar to the course catalog but only shows high school courses that have active enrollment this current school year.
Covid Related Reports

Bus Listing Greater Than 25

This report is based on only those Covid Survey responses that have replied 'Yes' the student was returning to school. Therefore, the 'Total' may not be the total number of students assigned to the bus, only those confirmed they are returning to school.

The buses listed are only those buses that have 26 or more 'Total' students for that bus. Those parent that replied that they would drive their child to school are counted as 'Refusing Bus'. Subtracting this number from the 'Total' will result in the number of riders on the bus.

Bus Listing Less Than 26

The buses listed are only those buses that have less than 26 'Total' students for that bus. Those parent that replied that they would drive their child to school are counted as 'Refusing Bus'. Subtracting this number from the 'Total' will result in the number of riders on the bus.

Covid Responses School Summary

This report is the summary for the current school of all active students for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Bus' column.

RUN WITHIN A SCHOOL

Covid Survey Page with Barcode

The purpose of this report is to list all students and the current data on the Covid Survey page including the barcode of the device if one was loaned to the student.

MUST BE RUN WITHIN A SCHOOL

Covid Survey Responses

The purpose of this report is to list all students and their parents' responses to the Covid Survey taken for the upcoming 2020-21 School year. Included is the response whether or not the parent will drive the student to school and the bus information from PowerSchool if the student is eligible busing. An additional column, 'Refused Busing' was added to indicate if the student was given busing but the parent has elected to drive the student both to and from school then the column will be 'Yes'.

RUN WITHIN A SCHOOL

Covid Survey Responses - District Wide

This report lists all active students in Bridgeport Public Schools for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not for the entire District. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Busing' column.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.

Restricted

Covid Survey Responses - Summary

This report is the summary by school of all active students in Bridgeport Public Schools for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not for the entire District. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Bus'

column.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.

Restricted

District Enrollment Summary

This report shows the total enrollment within each school in the District with the total students using in- school learning and those using distant learning.

Note: if the Covid Survey question of 'Is the student returning' is blank the assumption is distant learning.

Elementary All Homeroom Count

Using the Covid Survey Response 'Yes' to returning to school, this report identifies all homeroom within a school. This report uses the room number in the Section to identify classrooms. The grade of 'mixed' is for those self contained classrooms that will have different grade levels in the same room. The accuracy of this report is based on the accuracy of the room number and whether or not the teacher is identified as Special Ed.

Elementary Homeroom Count

Using the Covid Survey Response 'Yes' to returning to school, this report identifies any elementary homeroom with 15 or more students in the classroom, regardless of the number of students enrolled in the class. This is a District wide report and uses the room number in the Section to identify classrooms. The grade of 'mixed' is for those self contained classrooms that will have different grade levels in the same room. The accuracy of this report is based on the accuracy of the room number.

Elementary Rosters for District

The purpose of this report is to list all elementary schools and all students in the teacher's homeroom. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'.

Please note because it is District based, it take may take up to 5 minutes to run.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.

Restricted

Elementary Rosters with Distance Learning

The purpose of this report is to list all students in the teacher's homeroom within the school you are currently logged into. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'.

RUN WITHIN A SCHOOL

Elementary Rosters with Hybrid Days

The purpose of this report is to list all students in the teacher's homeroom within the school you are currently logged into. The report is similar to the previous roster report but is more focused on the students' on going school participation. Along with the student's Homeroom info there is the in-session days a student is to attend school. In addition, if your school has identified student's siblings, this report will display them if they are active in the same school.

NOTE: If the student is a Distance Learner, this will supersede the in-session days. However, in order to prepare for their return, you still want to schedule the in-session days.

RUN WITHIN A SCHOOL

High School Rosters for District

The purpose of this report is to list all high schools and all students on a teachers' roster by course. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'. Please note because it is District based, it take may take up to 5 minutes to run.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.

Restricted

High School Rosters with Distance Learning

The purpose of this report is to list all students in a teachers' roster by course for the school you are logged into currently. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'.

RUN WITHIN A SCHOOL

Pre-K Enrollment by School w/ Distance

The report will list all the Pre-K classes within the District and, if specified, list the grant type, teacher, teacher designation, course number and section, course name, number enrolled, number available (based on maximums of 8 SPED, 15 for Discovery or 18), a status and whether a full day or half. This version of the report contains the Covid responses by parents. Those parents that responded 'Yes' are counted as 'In-School'. Those that replied 'No' or those that didn't reply are counted as 'Distance'.

Pre-K Student Enrollment w/ Distance

This report lists all active and pre-registered students enrolled in a Pre-K classroom. Also listed is the teacher, teacher designation, classroom and whether the student has chosen Distance Learning, In-School or No Response as a preference.

School Listing with Learning Preference

Elementary school listing of all students within a school and their homeroom teacher along with the learning preference chosen by the parent, in-school vs. distant, as well as grade, SPED, ELL and School Messenger contact info.

RUN WITHIN A SCHOOL

Students Expected to Return

This report is intended to alert the school to enrolled students who are expected to return ti in-school learning in advance for their return date. The report was created to check the Covid Expected Return Date on the Survey screen and 7 days ahead.

Student's Pending Status

This report is intended to alert the school to enrolled students who are expected to either return to In- School or move to Distant Learning. The report was created to check the 'Expected Return to in-school learning' date and the 'Moving to Distant Learning on' date on the COVID Survey screen. This report adds the flexibility to enter your own search dates.

Students with Outstanding Invoices

The purpose of this report is to list students that may have a payment for repairs due on a school device. The invoice amount is entered in the Covid Survey page. It is meant to keep track of students that may owe money to the school for repairs. If more than one invoice is owed, the amount should be the sum of all invoices owed.

MUST BE RUN WITHIN A SCHOOL

Data Management

Active Staff Listing

This is a listing of all currently active staff with an active PowerSchool account. Please note, having an active PowerSchool account does not insure you have access to the PowerSchool databases. This version of the report can be run at any level but will return active staff District wide.

Active Teachers Summary

This report will list each school with the total of teachers assigned to the school, the number of lead teachers assigned to an active class and the number

of substitute teachers.

Restricted

Barcodes Captured in PowerSchool

This report is for use by ITS to review device barcodes recorded in PowerSchool and may not be captured in the Snipe-IT asset management system.

Capacity vs Enrollment

Capacity vs Enrollment for each School in the

district.

Claudia's School Days in a Month

The purpose of this report is to give an exact count of school days within a specific month for each

school based on their individual calendar.

Courses Used in Wrong Term

The purpose of this report is to identify high school courses with active sections using the wrong course for the term. If a course was created as a year long course and achieving 1 credit for that time period it would have a 'Y' as the 6th character in the course number. Therefore, if the course is used for a semester course which would typically earn 0.5 credit, at the end of the semester the student would actually earn 1 credit.

NOTE: Credit Recovery (CR) courses are not included in this report.

District Present Count

This report will show the number of Bridgeport students present, absent and enrolled in Bridgeport Schools on any school day for any year. For the purposes of this report the students enrolled in the following are not included in this report Non Reporting, Out Of District, Aqua Culture, TUS, and

BJDC

District Present Count with Remote

This report will show the number of students present and absent for both In School and Distant Learning for the entire District on a specific day. Please the purpose of this report is to show the overall presence of Bridgeport students attending a Bridgeport Public school. Therefore students enrolled in the following are not included in this report Non Reporting, Out Of District, Aqua Culture,

TUS, and BJDC

District Schools

List report will list all schools within the school table or jusr those that are currently active, including those non schools like OOD, NRP and others.

Duplicate Course Enrollment for District

This report will list all students throughout the District who are actively enrolled in the same course in more than one section. The last two columns indicate if the course gives grades (Grades) and takes attendance (Attn).

These duplicate enrollments will have an adverse effect on the students final grade and their attendance.

Duplicate Stored Grades

This report will list any student with duplicate grades that were stored in the the same marking period.

Included in the list is the course number and the section number. Any stored grade for a student who is no longer enrolled in that course will display

'Inactive CC'.

Elementary Sections with wrong grade

The purpose of this report is to identify those sections in the current school year for the elementary school where the grade level within the section does not match the grade level in the course number. For example SCI500 has a grade level of

0. This is very important because many of the reports are based on the grade level entered in the

section.

FTE ID's For All Schools in a Year

The purpose is to identify the FTE ID for a school within a particular school year. You must be in the school year you want the FTE for. However, the report only goes back to 2017-18 school year.

Locate Sections

This query is used to identify a section when you

only know the section ID

Missing In Session Days	This report is to list all active students without the COVID In Session Days. The report is intended to provide the missing Mon-Tue or Thu-Fri days of the week the student should be physically attending school based on the first letter in the last_name field. This information can be changed on the Covid Response Page but this report will not select the student if the field has already been filled.
No Shows for District	This report is meant to determine those students that never arrived since the first day of school. The report is for an individual school. Please note for High Schools the Daily attendance must be updated first. Since it is possible that a teacher didn't take attendance and therefore the student appears as Present, we have based the student output if their absences are within 75% of their membership days.
OOD and NRP Report	This is the first cut of a report to list all active OOD and NRP students along with their OOD school they attend, SPED & ELL status as well as the transportation fields that may be enabled.
OOD Busing Summary	This is a summary report to list all charter and parochial schools whose students in the Non Reporting Placement school are being bused or issued GBT passes.
Optimus Health Enrollment	This report will list all schools with active enrollments in Optimus Health care clinics.
Search - Custom Pages (CPM)	Find in which Custom Page(s) (CPM) a specific string is found.	Restricted
Staff email Errors	The purpose of this report is to list all active staff members and access to PowerSchool or PowerTeacher that may have an erroneous email address based on their LDAP login user name. When reviewing account for errors be sure to remove login ID and the LDAP indicator for PowerSchool or PowerTeacher that is not being used.
Students Without Classes in District	This report will list all students within the District that do not have any classes assigned to them.
Discipline and Other Log Entries
All Log Entries for a Student Within a Date Range	This report is intended to list all Log Entries for a single student within a date range. You have first selected a student or group of students but only one will be listed at a time.
Bullying Allegations Report	Listing of students that reported being bullied and when and who were the alleged bullies.
Discipline Entries by Grade Level	This report counts the number of discipline entries by grade for a school within a particular time frame.
Discipline Entry Count by Author	Count the number of discipline entries a person has created within a school.	Restricted

Discipline Log Entries by Student	This report allows an admin to search for discipline log entries for a student in the current school. The search will be based on dates entered by the admin.	Restricted
ISS, OSS Historic Data from 9/1/2014	This report will count the Unique Students and the total number of ISS and OSS Discipline Logs and number of days by the month. Please Note: During the current year the disciplinary sanctions will change as the discipline logs are edited. As a result, the data reflected in the report will change as the year comes to a close. The previous years' data should remain the same.
Log Entries by Author	This report is grouped by author and when expanded will list the category, student and entry date.
Log Entry Summary	The purpose of this report is to give admins a perspective of the number and types of student logs being create within the school for the current school year. The report will list the author of the log, whether currently in the school or not, and a count of each type of log that was entered.
Log Tally by Author	Counts all type of log entries by the author for a give time period.
Pending Log Entries	This report will replace the Pending Log Report on the Old Custom Reports tab. This reports the same log entries as distributed by the Crystal Reports.
Student Listing with a Count of OSS Sanctions	Purpose of this report is to listing only those students with at least 1 OSS sanction within the current school year. NOTE: this report is school based and must be run within a school.
Suspension Rates	This report displays the Suspension Rate for each school in the District. This rate is calculated by counting the students that have an ISS, OSS or Expulsion from the school where the incident took place divided by the total number of students attending a school within the current school year, whether currently active or not. NOTE: Since discipline logs are constantly being updated to report sanctions of ISS, OSS and Expulsions, the results of this report can change daily.
Top 5 Disciplinary Incidents by School	This report will list the top 5 ranked incidents regardless of any sanction which may or may not have occurred. NOTE: If two or more incident types have the same number of violations the Rank number will be the same and the top 5 will be shown. Therefore, it is possible to have more than 5 incident types listed.
District

District ISS, OSS Historic Data	This report will count the Unique Students and the total number of ISS and OSS Discipline Logs and number of days by the month for the entire District from 2014 to present. Please Note: During the current year the disciplinary sanctions will change as the discipline logs are edited. As a result, the data reflected in the report will change as the year comes to a close. The previous years' data should remain the same.
Guidance Counselor Summary	This report will list all schools with enrollment total and the number of students each guidance counselor is responsible for as defined in each student record. If no counselor is assigned to a student, it is reported as "No Cnslr".
Report Card Archive Summary	This report will list all schools and the total of currently active students, the name of each archived report card, the date they were created and the number of report cards archived for that report card.
School Days for All Schools	This report will list Bridgeport Public Schools and the number of days in session for the students within the current school year. This report counts only days that students should be in school for the current year.
School Messenger Email Summary	This report is intended to list all schools and the	Restricted
Early Childhood
Early Childhood Pre-K Readiness/Smart Start	List of individual Pre-K students and their classroom with other information to help compile data for School Readiness and Smart Start Reporting
Early Childhood Pre-K Student Listing	Listing of all active Pre-K students throughout the District for the current school year
Early Childhood Teacher Listing by Grant	This District wide report lists all schools with Pre-K classes and listing those teachers that are operating under a grant of any kind, as denoted on the demographics page along with the total number of students in their class.
New or Exited Pre-K Students	The report will list all Pre-K students that have either enrolled in a Pre-K school or exited from one during the specified date range.
Next Year Pre-K Enrollment Summary	The intention of this report is to estimate the number of children that have been enrolled into Pre-K. The report is based on the number of pre-registered students for grades -1 and -2 along with any student currently registered and next year grade is Pre-K. The accuracy of this report is dependent on the staff enrolling students into PowerSchool before the end of the current school year and if current 3 year olds will return for Pre-K next year, the next year grade is properly filled in.

NRP Student Report	This report will list all active students and inactive students that have been exited within the current school year enrolled in the NRP school. Along with the student their status, grade level, SPED, Entry Comment, Exit Comment and person who created the record will also be displayed.
NRP Students with Alerts	This report will list all active NRP students with an 'Alert - Other'
OOD Students with Alerts	This report will list all active OOD students with an 'Alert - Other'
Pre-K Enrollment by School	The report will list all the Pre-K classes within the District and, if specified, list the grant type, teacher, teacher designation, course number and section, course name, number enrolled, number available (based on maximums of 8 SPED, 15 for Discovery or 18), a status and whether a full day or half.
Pre-K Household Summary	This report will list only Pre-K students currently enrolled or recently exited in the School Readiness program. Contained in the report is the household information such as number of adults, children and income as captured from the online registration or input on the Early Childhood page. If the income was reported other than yearly, the report will calculate the yearly income and list the frequency times the number to get to yearly, i.e. weekly x 52.
Enrollment ‐ Course
Aquaculture Course Enrollment	Lists all students enrolled in all classes given at Aquaculture
College Level Enrollment & Prep.	Report designed to count the students enrolled in an AP, Dual Enrollment or any of the College & Career Prep. for any of the high schools. NOTE: Since Dual Enrollments are College Level, the numbers are not included in the cross total. Otherwise the totals would be doubled for those courses.
Course Enrollment for CL by School	This report counts the students enrolled in a College Level courses only by the school the course is given.
Course Totals by Grade Level	The total number of students at the current school enrolled in a course, broken down by grade levels.	Restricted
Current Course Enrollment	The intention of this report is to give and up to date account of the number of students enrolled in a class. As students are moved from one class to another, the section counts are not always accurate. This report uses the CC enrollments table not the Sections table which could have a delay before the student total is updated.

Duplicate Course Enrollment

This report will list all students within a school who are currently actively enrolled in the same course in more than one section. The last two columns indicate if the course gives grades (Grades) and takes attendance (Attn).

These duplicate enrollments will have an adverse effect on the students final grade and their attendance.

MUST BE RUN WITHIN A SCHOOL

Elementary Homeroom Listing

This report is intended to provide an alphabetical listing of all students within an elementary school and their Homeroom assignment. This report is based on the actual course enrollment. Therefore, it is the most current, whereas the Homeroom listed on the student header is only updated nightly. In addition, this report will show those students not

enrolled in a Homeroom.

Homeroom Rosters for Testing

With the purpose of testing in mind, this report will produce a list of all students enrolled in a homeroom class. The list will include the homeroom teacher, room number, grade, student number, student name, DOB, SASID, study ID, SPED, 504 and ELL data.

MUST BE RUN WITHIN A SCHOOL

Inactive Students with Active Classes

This report will list all students that are inactive by

way of Transferred Out or Graduated but are still on active rosters.

Inactive Teachers with Sections

This report will display all sections within a school that are assigned to a teacher that is no longer at the school whether he or she moved to another Bridgeport school, moved out of the District or retired. With the newly added ClassLink system, it is imperative that sections are always up to date.

Missing High School Homerooms

This report will list all students within a high School that does not have a Homeroom scheduled. The courses used in high school homerooms are AD009YPLGE, AD010YPLGE, AD011YPLGE,

AD012YPLGE, and AD013YPLGE. The program does not specify first period.

Rosters for NGSS

This report lists all students, along with the teacher, enrolled in any Science course in the current school year for a particular school. Any student enrolled in a course number beginning with "SC" is selected.

Rosters for SBAC

This report lists all students, along with the teacher, enrolled in an English or Math course in the current school year for a particular school. Any student enrolled in a course number beginning with "EN" or "MA" is selected.

Rosters for Social Studies

This report lists all students, along with the teacher, enrolled in any Social Studies course in the current school year for a particular school. Any student enrolled in a course number beginning with SS is

selected.

Student Schedule with Rooms by Period for S1

The report will list all enrolled students with the rooms they will be in for the 4 periods of a blocked schedule. Also included is their grade level,

responsible admin, and counselor.

Students Without Classes

The report is designed to show active students who are not enrolled in any classes.

NOTE: You must be logged into a school, will not

work in District.

Enrollment ‐ School

Bridgeport Students Enrollment by School

The purpose of this report is to give a count of enrolled students in each school. This report includes all active students that attend a Bridgeport Public School. This report excludes TUS, NRP,

OOD and BJDC.

Current Enrollment by School by Grade

The intention of this report is to quickly give an enrollment count at the time it is run. These counts may differ from the monthly reports and reports submitted to the State for the simple reason, enrollment numbers are always changing.

Included in the report is the "Type" this allows the user to select only high schools (HS), elementary (EL), unique programs (PGM) or special application schools (SP).

Enrollment Stats

This report will display the total number of enrolled students currently. As well as the total number of females, males, non-binary and missing gender. Also included is the number and percentage of the following free or reduced lunches, Special Ed students and ELL students.

This must be run within a school.

Ethnicity/Race by Grade Level

This report lists the total ethnicity, race and gender for each grade level within a specific school. The total count is the number of students in that grade level. with race completed.

Exited Students Within a Date Range

The purpose of this report is to display a list of

students who exited school within a date range.

New Students By Date Range

Shows new students by date range for a school regardless of whether they are new to the district or transferred from another school. Run within a

school.

Out of District Students

This report is intended to list all active students whose Resident Town Code is not Bridgeport (015) and is attending one of the Magnet Schools, Aero, Bio, IT, BMA or Discovery. The report will list the student's school as well as the current Home Address, including City, will be listed along with the Resident Town as it is recorded in PowerSchool.

Resident Town Code Errors

This report is intended for use by the Inter-district Magnet schools to identify only those students that may have errors in the District of Residence and/or the Resident Town code (RTC). Errors will include missing or incorrect RTC codes, misspelling of town/city names. In addition, the report will indicate the SPED status and Homeless status of the student. NOTE: This report must be run within a

school.

Resident Town Code for a School

This report is school based and lists students, the city where they live, the Resident Town Code (RTC), and the name of the city for the Resident Town Code. This will help identify errors before reporting

to the State.

Sibling Report

This report is intended to list active students within a specific school that the school had identified their siblings. The report allows you to select all siblings whether they are activly enrolled in a school or not. Warning: You must identify the sibling before running this report and the report must be run from

within a school.

Finance

Current Interdistrict Student Enrollment

This is a list of the currently enrolled out of district students for use as supporting documentation when submitting tuition statements to other Districts.

Restricted

Finacial Report from Student Page

The purpose of this report is to show all the invoices paid to outside services by student District wide.

Restricted

Interdistrict Magnet Current Enrollment

The purpose is to help the Business Office report and invoice neighboring towns for tuition for their Magnet students. This is the same report as the 'Interdistrict Magnet Enrollment Estimate' but instead of being an estimate it reports the currently enrolled out of district students.

Restricted

Interdistrict Magnet Enrollment Estimates

The purpose is to help the Business Office prepare an estimate for our Magnet students to other Districts. According to Section 10-264l (m)(l) of the CT General Statutes, Bridgeport is mandated to provide an estimate to each District for the upcoming school year. The estimate is to include the number of students by grade to each school and the estimated per pupil cost of tuition by May 15th.

The accuracy of this reports depends entirely on the data entered for the "Next Year Grade" and the Pre- Registration of all out of district magnet students by May 15th.

Restricted

SEDAC-G Export for Dianny

When updating SEDAC-G financial information for students that have already been reported, this report will pull the updated information from the OOD

Financial page in PowerSchool.

SEDAC-G Export for Dorothy

This export is still in testing and is intended to fit into

Dorothy's spreadsheet.

Restricted

SEDAC-G Export for PJ

This export is still in testing and is intended to fit into

PJ's spreadsheet.

Restricted

Grades

Assignment Scores Info by Teacher

Choose a teacher and the report will show when

scores were last updated.

Elementary Grades Averages 80 and Above

This Report lists students in grades 6, 7 and 8 with an average of 80% or better. This average is based on the Y1 percent grade in the teachers' Gradebook. Grades for terms not entered are not included in the average. Students with failing grades but still maintaining an 80 or above average are still included.

NOTE: Report must be run from the within a school

Elementary Term Grading Report

This Report lists students in grades 6, 7 and 8 with a minimum of 80% in all subjects with a specified marking period within a school.

NOTE 1: Report must be run from the within a school

NOTE 2: Homeroom typically have no grades and are therefore eliminated from the calculations.

GPA Errors in Historical Grades

This report will list all the errors having to do with the GPA's going back to the 2015-2016 school year (2500 term)based off of the letter grade. The intention is to identify grades that will impact the student's GPA. The quarterly marking period GPA's (Q1, Q2, etc.) will only impact the current quarter's Honor Roll. The Y1 grade will affect the student's final accumulative GPA. The current counselor and administrator are listed but the error may have been in a previous year and/or school. The errors can range from no GPA entered, to wrong Added Value, to missing percent grade, to incorrect GPA for the letter grade given.

NOTE: This report must be run from a school.

GPA's for all Students

This report will calculate the current GPA for each student based on the Y1 grades stored for the current high school. Therefore, if you run the report before the Q1 grades are stored and then run the same report after the store, those 'semester' courses will figure into the final GPA. The report allows you to filter, as a result you can select only a

single grade.

Gradebook vs Stored Grades

Generate a report showing all the discrepancies between the grades in the Teacher's Gradebook and those stored in the permanent database for a

specific school and marking period.

Over Age and Wrong Grade

This report will show over aged high school students within the grade level and/or those students in the wrong grade level based on credits earned. The criteria for the various grade level ages and the Aged comments are as follows

"So_Aged" - Students older than 16 with less than

6.0 earned credits

"Jr_Aged" - Students older than 17 with less than

12.5 earned credits

"Sr_Aged" - Students older than 18 with less than

19.0 earned credits

The "ERROR" field will indicate whether the student is "Older" or in the "Wrong Grade"

NOTE: You must run the report logged into a high school.

Progress Report Grades Only

This report is intended to show only the Progress report grades in Stored Grades table for the current

year.

Stored Grade Failures

Shows all Failed or Incomplete courses grades for the Y1 term and the students who have failed in

alpha order by Course

Stored Grades for Current Year

Report lists every student with a stored grade for any

subject within the current year.

Stored Grades for Select Term	This report must be executed within a school. The school year must also be set in PowerSchool at the top right hand side of page. This report will list the stored grades of all students for a given Term. These Terms are based on the terms set for the school and school year.
Stored Grades Listing	This report lists all records in the Historic Grades table by teacher, student, course and grades for a specific marking period of the current year. NOTE: This report must be run from within a school. ALSO NOTE: Since these records are from the stored grades table, counselors would be adding grades for new students coming in from outside of our District. These grades may not include the teacher name or a name not familiar to the present school. However, the report can be filtered to eliminate those records.
Stored Letter Grades with Wrong Percent	The purpose of this report is to show errors between the Letter Grade and what should be the range of the Percent Grade for that Letter Grade.
Health
504 Students for a School	This report will list any student within a selected school that has a Y in the 504 field or has a comment in the Alert_504 text field.
Alerts List	Shows students with built-in alerts (discipline, guardian, medical, other). Hover over the icon to see the alert text. Can be run for the entire student body or just the current selection.
February Concussion Report	This report is intended to report concussion incidents to the State for the District broken down by grade and gender. Since a nurse cannot diagnose a concussion, this report looks for the word "concussion" within the Assessment field of the Office Visit. If found the visit is added to the grade level count. The report uses the date range from the start of the current school year until February 1 of the next year.	Restricted
Health Category Summary	Counts the number of office visits to the nurse by the category that was entered.	Restricted
Health Office Visits	List a student's history of visits to the nurse	Restricted
Home Bound Report	Lists all active students which are marked as Homebound.	Restricted
Lizette's Select School & Grade Report	This report lists only active students attending Blackham, Cesar Batalla or Read and only in grades K, 1, 3, 4 and 5
Office Visits for a School	This report will list all office visits for a school where the visit took place within a specific date range.

Recently Entered Students

Purpose of this report is to alert nurses to any new

students entering their school

School Listing of Medical Alerts

This is a listing of all students within the school you are logged into that have Medical Alerts and the date when the alert expires. Note that you must be in the school you want the listing of. Also, only students with Medical Alerts that exist on the Emergency Contact/Medical page will appear on the report.

Students with Allergies

List all active students within a school where the allergy field has been filled in from the student's

Emergency Contact/Medical page.

Restricted

Home Language Survey

District Wide All Students Home Lang. Survey

This is a District listing of all students in all school with the exception of OOD and NRP. The report details the Home Language Survey results for the student in addition to the 504, SPED and Ell

indicators.

District Wide Home Lang. Survey ELL ONLY

This report will list every student in the District currently marked as ELL and list their Home Language Survet results for questions 1 through 6. Also included in the student details is the LDC and

ELL Code.

Restricted

Home Language Survey

This report will list every student in a school and list their Home Language Survey results for questions 1 through 6. Each student is marked ELL (Y or N) and the report allows you to filter the results.

Students Requesting Translation

This is a listing of all active students within the District that have answered "Yes" to question 5 or 6 on the Home Language Survey which is requesting

a translation or an interpreter.

Students Requesting Translation Summary

This is summary report for all active students District wide which have requested communications to be translated or have requested an interpreter for

meetings.

Misc Student Listing

504, SPED and ELL Listing

This report will display any active student with SPED, 504 or ELL indicators. Since a student can't have an IEP and a 504 at the same time, there is a 504 Err column to identify these errors.

NOTE: This report must be run within a school.

Birthday Listing

This report will list all students within the school currently logged into that have a birthday in the

month chosen.

Exited Students Without Withdrawal Form

The purpose of this report is to identify those students that have been exited from school without a Withdrawal Form or a Request for Records.

Restricted

Grade Level vs Grade by Credit Hrs	The intention of this report is to list all students within a high school by their present grade assignment. Based on the student's earned credits it will determine what grade the student should be in. The first year of high school is calculated from the historical grades table. Using the earliest recorded year for grades stored when student was in 9th grade. If the student transferred into a Bridgeport high school, it is imperative the guidance counselor record the correct and complete information into the historical grades table. In addition, the report calculates if the student has repeated a grade by subtracting the student's first year of high school from the current school year and comparing the difference. The data displayed in the report is the student number, name, 1st year of high school,repeat or not, current grade, DOB, age, SPED, ELL, number of credits earned and what the grade should be based on the credits. NOTE: The grade level from credits is based on whether the student started school before 2019 when the required credits to graduate was 22.5 or after when the credits required are 25. Also, this report does take a few minutes to run and must be run within a school.
High School Students in Wrong Grade Level	The purpose of this report is to identify those students that should be in a different grade level based on their accumulated credit hours. Students with special needs may have more credits than necessary to graduate. Therefore, the report will identify these SPED students with more credits as a grade "13". Those student with more credits but without special needs will have a the suggested grades as "99".
Homebound Students by School	A listing of current Homebound students within a specific school.
Homeless List by School	List students with Homeless status
Homeless Listing for District	This is available only to District Admins	Restricted
Missing Internet OR Media OR Birth Doc	The purpose of this report is to list all students in a school that are missing either the Internet Policy, Media Policy or Birth Certificate/Passport. Please note this report is based on a document is uploaded and saved as an Internet or Media or Birth document. It does not read the actual document. However, with the new online registration the Internet and Media policies questions are answered electronically. Therefore, if the parent has refused consent for either the student will be listed with an 'R' in either or both categories. NOTE: You need to be in a school to run the report.

NRP OOD Students Current Year	The purpose of this report is to list all students in NRP or OOD that were enrolled in PowerSchool in the current year from 7/1 to 6/30.
Number of Years Student in HS	Listing of active students from a high school and the number of years spent in grades 9 through 12
SPED Error Report	Report to list SPED indicator = Y without a Student Disability Designation (SDD) and SPED = N with a Student Disability Designation (SDD)
SPED Students Within a School	Lists all SPED students by grade level with Contact being the Homeroom Teacher or Responsible Admin and/or Counselor as well as the Case Managers. Newly added is the CEP column. Continued Educational Plan (CEP) are the documents uploaded to Attachments so as not to interfere with the FrontLine IEP plans which are in place. NOTE: You must be in a school to run this report.
Student Emails	The results will be all emails associated with the active students in the school, including parents, guardian emails and the student's Bridgeport email or the one he/she has entered. Also included is the School Messenger phone contacts in case there are no email addresses given for the student. This report must be run from within a school.
Students and Parent Access Accounts	This report will list the entire student population and any parent/guardian access accounts they may have. The report allows you to filter by grade and those with and without parent accounts. If a student has more than one parent account these will be grouped together by the student.
Students missing Ethnicity/Race	Just as the title indicates, this report lists all active
Students Repeating Grade	Report displays students within a school repeating the same grade based on a comparison of current grade level stored grade level from previous school year.
Talented and Gifted (TAG)	Lists all students identified on the State page that have a TAG code (02 through 09)
Miscellaneous
Calculate Insession School Days	The purpose of this report is to determine the number of school membership days between two dates. NOTE: You need to be logged into a school in order to run report.
Instructional Time by Section and Term	The purpose of this report is to show the total amount of instructional or seat time that each section has for duration of the term it is being offered in.
Next Year Reports

Invalid CC Records in PowerScheduler

The purpose of this report is to identify those student who are no longer going to attend the school you are current signed into. Normally, these requests would not be filled but a last minute decision by the student could cause this to happen. These records should be removed from the PowerScheduler CC table. To correct, be sure the requests have been removed and perform another Load. This will remove the current CC records and write all new records thereby eliminating these erroneous records.

Invalid Requests

This report will list all students and their requests for next year courses that are no longer intend on going to the current school you are presently signed into. The determination of whether a student intends on coming to the current school is based on what the Next School is on the Scheduling Setup page. For example, if a Columbus student intended to go to Bassick entered Course Requests but now is going to Aero and the requests were not removed, the student will appear in this report.

Next Year Enrollment by Section

Shows the student enrollment of next year's courses

when it sin't available in PowerSchool because the first term hasn't started yet.

Restricted

Next Year Error Report for All Grades

This report lists students that may have an error with Next Year School and/or Next Year Grade.

NOTE: This report has been updated and must now be run within a school.

Next Year Error Report for District

This report displays that may prevent the End Of Year Roll-Up from running. The report lists errors and possible errors. For example, if the Next Year School is missing the Roll-Up will not run. However, if the next year grade is blank, this will translate to a 0 indicating Kindergarten. If an elementary student is in 7th grade and the next year grade is missing that student will be a kindergartner come the fall.

Next Year School for 8th Graders

This report is primarily intended to be reviewed by counselors prior to the year end roll-up. The report will list all active 8th grade students along with their current homeroom, homeroom teacher, Next Grade, Next School and whether the student is to be scheduled by a Bridgeport District High School or not. Also included is a column to alert you to any possible errors. For example the student's Next Year Grade is 8 but his/her Term Report is marked "Retained - No" the error would read 'Should Next Grade be 9'.

You must be in a school to run this report.

Percent Scheduled for Next Year

This report provides the number of students by grade by sending school that have requests

scheduled for next year for the receiving school.

Review Students for Next Year Placement	Developed for Skane, the purpose of this report is to list all active students and specific information and their next year school and grade and a blank field to include their next program.
ScheduleCC Report from PowerScheduler	The intention of this report is to give an Admin the ability to see students' next year schedules, as long as the Admin has Loaded the courses with students in PowerScheduler. The program is written from the time before the End Of Year Rollup. Once the Rollup has been done and the "Current" year is set to the next year, this report will fail. One other note, depending on the size of the school, may take longer to run. As a result, the report may appear finished but until the alternating blue strips appear, the report is still building. A warning may appear warning your browser has slower due to the page, just ignore. Lastly, you must be in a school to run the report.
Students Not Pointed to Same HS Next Year	In preparation for the End of Year Roll-up, this report lists all students in grades 9 through 12 whose Next Year School is not the same as their present school. This situation occurs when a student transfers from one school to another and the "Scheduling Setup" page is not modified to reflect the new school.	Restricted
Students Without Requests	This report will list all students that are checked for scheduling on their 'Scheduling Setup' page but do not have any course requests for next year.
Nutrition
Breakfast Report	This reports on all elementary schools the enrollment total, total attendance for the day, the number for breakfasts served and those refused for a specific day
CSA Supper Listing	Report will list all students Present for the date submitted for Classical Studies and the Annex in one listing
Scheduling
Class Requests	Lists Student's course requests for next year.	Restricted
High School Next Year Request Summary	The intention of this report is to show a student's requests for next year. The report will count the number of requests, display the courses requested and total the number of possible credits. You must be within a high school to run the report.

High School Scheduling Report	This report is intended to help schedule high school students. The report is based on the current year (not PowerScheduler). Students are listed by grade then alpha and will appear several times. Each line consists of the term and courses within that term. '20- 21' is a full year course spanning S1 and S2. Since we are running block schedules a semester course would take place in a quarter, therefore, there is a 'Term A' and a 'Term B' to identify quarter courses within a semester. This report must be run within a school.
Incorrect Course Number Used	This report will list all courses within a school that have a .5 credit course being used as a 1 credit course and vice versa based on our present block schedule. This report will search the active section and can be used for any school year but not in PowerScheduler..
Schedule of Days Off for a School	This report will list the days with no school scheduled for the current entire school year for a specific school, including snow days.
Student High School Course Requests	This report will list all the student requests currently entered into PowerSchool. You must be in a High School to retrieve the information.
Student Transferred Out But Not Yet Enrolled	This report lists all students within a selected school that have been transferred out with an exit code of "01" or have been transferred into the selected school with an "01" without being enrolled into the receiving school.
Students Without Classes	This report will list all students currently enrolled in school but have not been assigned any classes. At present the BJDC has been omitted form this report.
School_Messenger
School Messenger Student Email & Phone	This report is intended to show all School Messenger emails and phone numbers currently listed on the student's Demographics page within a school. The report must be run within a school and not at District Office.
Staff
Active Counselors	This report will list all active counselors along with the school they service. The listing is based on the school, therefore, a counselor may appear multiple times if they service more than one school.
Active Staff Listing	This is a listing of all currently active staff with an active PowerSchool account. Please note, having an active PowerSchool account does not insure you have access to the PowerSchool databases. Also note, this report must be run within a school, not at District level. Please report any staff members no longer at your school to the Data Management Dept.

Active Staff Listing for District	This is a listing of all currently active staff with an active PowerSchool account within the entire District. Please note, the staff member may appear more than once. The reason is that the staff member may be active at more than one location. Also, having an active PowerSchool account does not insure you have access to the PowerSchool database.
High School Teachers and Subject Taught	Set for the current school year, this report will search all high schools with students enrolled in sections and list each teacher and their subject they are teaching.
High School Teachers Count within a Department	This report will list a Subject/Department taught within the school and the number of teacher, teaching that subject for the current school year. The subject is based on the first two digits of the course number.
Inactive Teachers with Classes	Lists all classes that have an inactive teacher as the lead teacher.
Last Gradebook Update	This report will show those teachers who have not updated any grades the gradebook for a section based on the date you enter. The report does not look at updates regarding standards. Only sections that are in session on that date are shown. For example, if you enter a date that is outside the date range of S2 sections, then those sections are not included.
List of AP Teachers	This report provides of a list of teachers with active AP courses. The classes must have students actively enrolled for the teacher to be listed.
Staff With Classes	The purpose of this report is to identify staff members with active classes who may be a certified teacher whose 'staffstatus' is 'staff' instead of 'teacher'. The security group the staff member is in will help determine if the individual had been certified but has now taken a new position.
Teachers with Classes	Using the class sections for all Bridgeport schools for the current year, the report will list every teacher designated as Lead Teacher within a school, along with the school they are teaching at and their email address. NOTE: If a teacher is teaching classes in more than one school, the teacher will be listed in all the school he/she teaches in.
Student Support Services
Creator Summary	A summary count of all Student Support visits created by an individual throughout the District.
Individual Student Entries	Report details for all entries for an individual student selected by the drop down menu.	Restricted
Purpose of Visit by Student	Listing of students for a selected school with a summary of their visits with a count of the purpose of their.

Purpose Summary	Report to count the number visits by the Purpose of the Visit for the District.
Service Summary if Referred	A summary of services provided by school for students with a Referral for the District.
Service Summary if Referred and Accessed	A summary of Services by school rendered only if Referred and Accessed for the District.
Service Summary other than Referred	A summary of services provided by school for students other than Referred for the District.
Student Support Visit Summary by Staff Position	Summary of the number of visits by the staff position for the District.
Student Visits by Time for a School	Summary of when students visit by morning, after lunch and after school for a school selected at the beginning of the report.
Student Visits by Time for District	Summary of when students visit by morning, after lunch and after school for the entire District.
Students with Support Visits	List all students with any Support Service records within a time range
Summer School
~SSEL Attendance Taken for a Day	NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool. The report will list all schools and the attendance totals for a specific day.
~SSEL School Summary by Team	NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool. This report will count all the students actively enrolled in the Elementary Summer school by the school they were enrolled in at the end of the current school year.
~SSEL Student List by Enrollment	NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool. Summer School students enrolled in a course represents the Summer School the student is attending. This report lists each active student with the school abbreviation they attended during their normal school year (represented by Team) along with the Summer School they are currently attending.
~SSEL Student Not in a Summer School	NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool. This report lists all students active in the Summer School but are not enrolled in a Summer School. Also listed as Home School is where the student attended during regular school year.

~SSEL Students Enrolled in more than 1 School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

This report is to identify those students enrolled in more than one Summer School at the same time. Having a student enrolled in more than one course will cause the SSEL Student List by Enrollment and SSEL Student Not in a Summer School Reports not to run.

Summer School Home School to SS

List students from your school who are attending a

summer school

Summer School Home School to SS - District

List students from the District who are attending a

summer school

Restricted

Summer School Students

This report will list all students that have been

recommended for Summer School.

Summer School Summary

This report will count the students in Kindergarten to grade 3 and registered to a school school by the summer school. Although the report contains the count of students tagged in PowerSchool attending ESY, the Dept. of Specialize Instruction provides its own list of ESY students.

Summer School To Home School

List of students from throughout the District

attending your summer school

Teachers (PST) (Must be in PowerTeacher)

Class Enrollment History (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

Choose a section and see the enrollment history of students in that section. Will show active and dropped students.

Restricted

Current Classes (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

This report will show where students are enrolled in on the current day based on the period entered in the first box below. You can run the report for just a section or for the entire student body. Students with free periods will not appear on the report. Only enter one period and only enter the period number. For example, you only need to enter 2 for period 2, regardless if it's 2(A), 2(B), 2(A-B), etc.

Restricted

Discipline Log Entries (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

This report will show discipline log entries of all the students a teacher has in class. The log entries will start based on a date entered by the teacher.

Restricted

Elementary Classes Current Year (PST)

This report is intended for elementary 'Specials' teachers. It shows their scheduled classes for the current year and the homerooms associated with that class. NOTE: You must be logged in as a

elementary teacher.

Restricted

Log Entries by Student (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

Teachers can choose one of their students and a starting date and see any discipline log entries that have been created for that student.

Restricted

Missing Internet Policy or Media Release (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

The purpose of this report is to list all students in a teacher's class that are missing either the Internet Policy or Media Policy. Please note this report is based on a document is uploaded and saved as an Internet or Media document. It does not read the actual document.

Restricted

Optimus Student Rosters (PST)

The purpose of this report is to produce a simple list of all students in one of the teacher's assigned

classes which can be easily printed.

Restricted

Parent & Emergency Phone Numbers (PST)

This is a listing of all phone numbers associated with each student in the selected class, including mother's & father's cell and home phones if living separate. Also included are all emergency contact numbers from the enrollments.

Restricted

Parent emails by class to copy and paste (PST)

The purpose of this report group all parent and guardian emails from a single course into one field to copy and paste into an Outlook address 'TO' field.

Restricted

Roster for Teams Meeting (PST)

The purpose of this report group all emails from a single course into one field to copy and paste into a

Teams or Outlook address 'TO' field.

Restricted

Sections Taught Current Year (PST)

This report is intended to show the logged in teacher all classes he/she is assigned to teach for the current year. In addition to the course number, section number, course name, term length, section ID and number of active students. NOTE: You must be logged in as a teacher.

Restricted

Student & Parent Emails (PST)

The purpose of this report is to list all students in one of the teacher's assigned classes with all the School Messenger and parent contacts in one location. The list can be sorted and filtered.

Although the report can be printed, due to the number of columns, it is recommended to export the data to a "CSV" file. This file can be opened with

Excel.

Restricted

Student Absences for a Class (PST)

The purpose of this report is to list the students within the class that have more than 4 absences for

this class.

Restricted

Student Enrollment Distant or In School (PST)

The purpose of this report is to list all students in one of the teacher's assigned classes with student's name, grade, homeroom, if applicable and whether the student is a distant learner or in-school. Since all in-school students will be returning to meeting Monday, Tuesday, Thursday and Friday with remote learning on Wednesday the column 'In Session Days' has been remove to eliminate confusion.

Restricted

Student Log Entries (PST)

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

A list of all log types for a student except Health and Social Work will be produced.

Restricted

Student Rosters (PST)

The purpose of this report is to produce a simple list of all students in one of the teacher's assigned

classes which can be easily printed.

Restricted

Student SBAC Testing Report(PST)

The purpose of this report is to list all students in one of the teacher's assigned classes with the student's State Assigned Student ID (SASID) in order for the student to sign into the SBAC testing

sight.

Restricted

Student Test Scores (PST)

A list of test scores a student has taken grouped by

test.

Restricted

Student Testing Report(PST)

The purpose of this report is to list all students in one of the teacher's assigned classes with the student's study ID in order for the student to sign into

the Testing sight.

Restricted

Transportation

Bus Counts for District

Counts active students who are assigned a bus

number

Bus Lists By School

Bus list containing students listed by bus number

Bus Stops By School

This report will list the bus stops and a count of the number of students at that stop for a particular school. The report is driven by the data exchange between active students in PowerSchool and the information received nightly from Transfinder.

Homeroom Listing with Busing Info

The report will list all active students by Homeroom along with their busing information or if they do not get busing. Please note, the homeroom is identified after a nightly process. If a student was enrolled into a new homeroom, the correct room number and teacher won't appear until the next school day.

OOD Bus Count by School

This report lists all Out of District schools, such as charter and parochial schools, where we are busing our Bridgeport students to these other schools and the total number of students being bused.

Student Summary By School Including NRP

This report is indented to list all active students attending a school including those students at charter and parochial schools listed under the NRP school. These student will have the school indicator within their record and will be accounted for under the abbreviation. This is to enable a comparison between PowerSchool and TransFinder.

NOTE: Since TransFinder uses the school's abbreviation as the key, this run uses the same abbreviations.

Uncategorized

Duplicate Storedgrades

The purpose of this report is to identify students with more than one stored grade of a marking period.

This may indicate the student is enrolled in more than one section of the same course number.

SBAC Tests by Grade Level

This is an experimental test to collect SBAC scores

for a grade for the school you are presently in PowerSchool.

sqlReports Information

List of reports in sqlReports by category, including access groups and last time they were run.

Student Enrollment History

The report is intended to show a student's enrollment history from the very first year in Bridgeport School System. Along with the year is the school or schools attended, grade level, membership, absences and final courses and grades at the school.

You must select a student or students BEFORE running this report.

However, currently this report can only retrieve this

information back to 2012-2013 school year.

Student Test Scores

A list of test scores a student has taken grouped by

test.